USE [MSPetShopOrders]

if not exists (select * from master.dbo.syslogins where loginname = N'mspetshoporders')
BEGIN
	exec sp_addlogin 'mspetshoporders' ,'password', 'MSPetShopOrders'
END

exec sp_grantdbaccess 'mspetshoporders'

exec sp_addrolemember 'db_owner', 'mspetshoporders'
